(Sun Microsystems, Inc.)(1997).iso/products/IBM/comservr.gif)
Visual Explain
Visual Explain is a graphical utility that provides a visual representation
of the access plans that the DB2 optimizer uses to obtain data for an SQL
statement.
(Sun Microsystems, Inc.)(1997).iso/products/IBM/vexplain.gif)
(Sun Microsystems, Inc.)(1997).iso/products/IBM/grenrule.gif)
Visual Explain lets you view queries at varying levels
of detail.
(Sun Microsystems, Inc.)(1997).iso/products/IBM/grenrul2.gif)
|
You can use Visual Explain to:
- View the details of the access plan including statistics in the system
catablogs.
- Tune SQL statements for better performance.
- Model the impact of environment changes on SQL statements.
- Determine the source of problems in SQL statements.
|
(Sun Microsystems, Inc.)(1997).iso/products/IBM/swmast1.gif)
(Sun Microsystems, Inc.)(1997).iso/products/IBM/swani.gif)
(Sun Microsystems, Inc.)(1997).iso/products/IBM/spacer.gif){kind=spacer}
(Sun Microsystems, Inc.)(1997).iso/products/IBM/home.gif){kind=small}
(Sun Microsystems, Inc.)(1997).iso/products/IBM/order.gif){kind=small}
(Sun Microsystems, Inc.)(1997).iso/products/IBM/search.gif){kind=small}
(Sun Microsystems, Inc.)(1997).iso/products/IBM/contact.gif){kind=small}
(Sun Microsystems, Inc.)(1997).iso/products/IBM/legal.gif){kind=small}